Customer Login

Book a demo call

Build AI Agents on MS SQL Server

Build intelligent AI Agents on top of MS SQL Server with Peliqan, the leading data foundation for the Agentic AI world.

Request a demo

  • No credit card required
  •  5-minute setup
  • SOC 2 Type II certified

MS SQL Server

Build AI Agents

Build AI Agents on top of MS SQL Server

Build intelligent AI Agents on top of MS SQL Server, with Peliqan’s AI data foundation:

  • MS SQL Server MCP Server
  • MS SQL Server in n8n AI Agents
  • MS SQL Server in Make
  • “Text to SQL” on MS SQL Server data
  • MS SQL Server RAG with out-of-the-box embeddings (vectors)
  • MS SQL Server Graph RAG
  • Query unified 360° data combining MS SQL Server and other data

MS SQL Server MCP Server

Publish a MS SQL Server MCP Server to query data from MS SQL Server and to take actions in MS SQL Server such as doing updates and adding new data in MS SQL Server.

Read more on MCP

Build MCP Server

Build AI agents in n8n

MS SQL Server in n8n

Build AI Chatbots and AI Agents in n8n that can perform “Text to SQL” to query MS SQL Server data and perform RAG and Graph RAG on information from MS SQL Server.

Read more on AI agents in n8n

Implement a “Text to SQL” chatbot on MS SQL Server

Implement an AI Chatbot that can answer analytical data questions on MS SQL Server data using “Text to SQL”. 

Text to SQL

Implement a chatbot

Implement a chatbot with RAG on MS SQL Server

Implement RAG (retrieval-augmented generation) on MS SQL Server data with an out-of-the-box vector store (embeddings) of all business entities and other information in MS SQL Server.

Combine MS SQL Server data with 250+ sources

Combine data from MS SQL Server with data from 250+ other connectors, and build 360° views of business entities such as customers, leads, products, employees etc.

Feed unified 360° data models to your AI Agents with RAG and “Text to SQL”. Allow your AI Agents to access all business data in one uniform data model.

Combine data

Prepare your MS SQL Server data for AI

Access, combine, and report on data from MS SQL Server and all your SaaS apps instantly. Gain valuable insights by bringing all your business data together in one place within minutes.

Explore the cockpit
SaaS Data Cockpit

Unify, Automate & Activate Your Data 

Connect all your SaaS apps, databases, and spreadsheets into one workspace. Build automations, analytics pipelines, and data apps — all in one place.

Book a demo

G2 Badges

Frequently Asked Questions

Why do I need Peliqan for my AI ?

Peliqan is an all-in-one data platform with 250+ data connectors (ERP, CRM, Accounting, ATS/HRM, cloud storage etc.) – including MS SQL Server – and a built-in data warehouse. Peliqan allows you to unleash, prepare and combine your MS SQL Server data for AI, including relational & non-relational data. Peliqan turns your MS SQL Server data into 360° views that can be used in AI Agents built in n8n, Make, langChain, langGraph or any other framework. Use Peliqan to create embeddings, store them in a vector store so that your AI chatbots can use RAG and Graph RAG, combined with Text-to-SQL for analytical reasoning. Peliqan is the only platform that allows your AI Agents to combine RAG and Text-to-SQL to apply deep reasoning on your MS SQL Server data. Use Peliqan to expose any MS SQL Server as an MCP server to query data and to take actions.

There are different ways to build an AI agent that can query data in MS SQL Server and take actions in MS SQL Server. For example you can build an AI agent in n8n and use Peliqan as the data foundation. Peliqan will sync your MS SQL Server data to its built-in data warehouse and allow the AI Agent to perform “Text to SQL” and RAG to answer questions and to perform reasoning on MS SQL Server data, combined with data from 250+ other sources.

First sign up for a free trial on Peliqan.io, next connect MS SQL Server in Peliqan. Once that is done, create an AI agent in n8n and use the Peliqan n8n node in your worflow. Add Peliqan as a “tool” to your AI Agent node, so that the AI agent can query your MS SQL Server data using Text to SQL.

There are different options to use RAG (retrieval augmented generation) in your AI Agent with MS SQL Server data. One option is to create a workflow in n8n that fetches all MS SQL Server data from Peliqan and stores it in Supabase as a vector store, with embeddings created using e.g. OpenAI.

In Peliqan, you can set up API endpoints and expose them as MCP Server. In the API endpoint handler script, you can configure actions to be taken in MS SQL Server such as querying data, doing lookups, adding new items or performing updates.

n8n is a great tool to build AI chatbots that use Text to SQL, to answer any analytical question on your MS SQL Server data. Any question will be converted by the AI agent into an SQL query, which is executed by Peliqan on the MS SQL Server data in the data warehouse.

In order to prepare your MS SQL Server data for RAG, you need to create embeddings and store them in a vector store. This can be done by creating a workflow in n8n that fetches all MS SQL Server data from Peliqan and stores it in Supabase as a vector store, with embeddings created using e.g. OpenAI.

Peliqan data platform

All-in-one Data Platform

Built-in data warehouse, superior data activation capabilities, and AI-powered development assistance.

Peliqan is secure

 Here’s why founders, CIOs, and their IT teams trust us with their data.

SOC 2 Type II

SOC 2 Type 2 validates our security controls, ensuring your data is protected by independently audited security measures.

ISO 27001

ISO 27001 certification (in progress) ensures enterprise-grade information security, protecting your business with globally recognized standards.

GDPR

GDPR compliance guarantees EU data protection compliance, keeping PII data secure within EU boundaries.

Ready to get instant access to all your company data ?

Request a demo